package shop;

import common.db.*;
import common.main.*;
import java.util.*;

public class GoodsInfoBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String gno = (String)inputTable.get("gno");
		
		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT NAME, KIND, PRICE, UNIT, IMAGE, CODE, GNO, INVEN, WAY, MILEAGE, CONTENT, ORIGIN ");
		queryBuffer.append("FROM GOODS ");
		queryBuffer.append("WHERE DISPLAYYN='Y' AND USEYN='Y' AND GNO='"+gno+"' ");
		queryBuffer.append("ORDER BY SEQ ");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}